UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'DXs10VF5D15WdSDhzy3Bp5OQn8JdyRTF0hsaaf4EPfk='
WHERE
key_id = '87077a4d44100eeb171284a15c5d51d57a92ded584ad26b846960435fd984c7c'
AND (
token = 'DXs10VF5D15WdSDhzy3Bp5OQn8JdyRTF0hsaaf4EPfk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)