UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'b9ZsnoUi8HjSCSunewWbYRYwpY9oWki+VuUTSh5FggA='
WHERE
key_id = '7904a85bc431e59ae5e58ee23348343e5fafb60c47485cc606fc876f3c988c7f'
AND (
token = 'b9ZsnoUi8HjSCSunewWbYRYwpY9oWki+VuUTSh5FggA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)