UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZyZhQ0ZnT6iQhAoMaW7mBaiZFXOoTOLYXSR/UIFDgHU='
WHERE
key_id = 'd59a3d9246e3ad45206676285244673bc13ce24523150139d545049379b82a2e'
AND (
token = 'ZyZhQ0ZnT6iQhAoMaW7mBaiZFXOoTOLYXSR/UIFDgHU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)