UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'rEiu/g4244TkHL+9TKSJewJwZU1TmnHrIxfx4iv8g/c='
WHERE
key_id = '093bc740658aa14482b03855a2fe3f5412c806b34578e1592e92ffb0eb29ea96'
AND (
token = 'rEiu/g4244TkHL+9TKSJewJwZU1TmnHrIxfx4iv8g/c='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)