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