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