UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XlkH9uW0ZBV6sVFo1sq4S8OUH22Rfe1GKRve79ZkGjc='
WHERE
key_id = '980ce1de8d2375a25980957e731b17b7087775a22f4eaf002833de75819d214a'
AND (
token = 'XlkH9uW0ZBV6sVFo1sq4S8OUH22Rfe1GKRve79ZkGjc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)