UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XEFpAapnNXQphxnaOtDYDbSyM5hDoRi5kxq7R+azN/8='
WHERE
key_id = '7db6523040b57139509cba0e42b8812316e33f695feeaf33f8a24c255a77d501'
AND (
token = 'XEFpAapnNXQphxnaOtDYDbSyM5hDoRi5kxq7R+azN/8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)