UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0COSyxeMESPR2g6MJnGXsfG0hQiZpHfghJXcf6tAKrw='
WHERE
key_id = 'a6396b55a45cd8a3445a174fc01dad69e5fc6e3551e2b32d5a89893e8f6b4ead'
AND (
token = '0COSyxeMESPR2g6MJnGXsfG0hQiZpHfghJXcf6tAKrw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)