UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZUi/QjL8ps9I8F45XOmqhPkOb/lLeLcCTHeuIlk/fd0='
WHERE
key_id = '3c6559fc01c06c9a19a073118f766abafd40979f88460e6f53be97d70eb986a8'
AND (
token = 'ZUi/QjL8ps9I8F45XOmqhPkOb/lLeLcCTHeuIlk/fd0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)