UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '30atKaqK+vE0In9oHju5/tkwCN6gKts27S+VBFXSuCc='
WHERE
key_id = '10618a2ff7e7be58241c722a6030fe393eac83ee7e9b36b3a4b465ec761ee601'
AND (
token = '30atKaqK+vE0In9oHju5/tkwCN6gKts27S+VBFXSuCc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)