UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'n7LjSRpcSC05omEquZrhtB5XuREv9HU+PyN/X1Sg/tI='
WHERE
key_id = '8b47d6d89517e7da50a6effec0e752f3959e3d9e7367d6ce37d5036286e77a07'
AND (
token = 'n7LjSRpcSC05omEquZrhtB5XuREv9HU+PyN/X1Sg/tI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)