UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pLjuXybBoF2URcG34oZCCap7GldF0HS6zu8vtJ8aOAY='
WHERE
key_id = 'e2c75120a809975dbb9a14b69672ac56ac62813a0b63de9e862287a585b3474c'
AND (
token = 'pLjuXybBoF2URcG34oZCCap7GldF0HS6zu8vtJ8aOAY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)