UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'k9VoDtcbVts8qdQb558rwF649PQefyL5T0wSk2S/tu4='
WHERE
key_id = 'f7fa42d9b12ce30b9736e71235da2a706fd89edbbcf71d2135c51ad942d9b1f9'
AND (
token = 'k9VoDtcbVts8qdQb558rwF649PQefyL5T0wSk2S/tu4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)