UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'S21XwrP3aT01znI7vHb9zu1P4czGHYh6Nz5pIec3iK8='
WHERE
key_id = '3e8cb54e8a3c4bfd5705c15ceb1f2245951aab4daaa316d465da6cf11e3b6292'
AND (
token = 'S21XwrP3aT01znI7vHb9zu1P4czGHYh6Nz5pIec3iK8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)