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