UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'H79PDB1ZzSmA2pcN7rEbZXfwkC1WK6GCXw98wFxmfJs='
WHERE
key_id = 'f3f125a02d6756c1138155a264c012d335a8c26de6a33d7543026b673bfa2ca4'
AND (
token = 'H79PDB1ZzSmA2pcN7rEbZXfwkC1WK6GCXw98wFxmfJs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)