UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'SC1sErid+Bee0+E8AJBDhxl5BAraIhmZvhJBcdByw4I='
WHERE
key_id = '8bbee458b8a8cd9c0e43ee5958cb95f0c9c5471f22c25c97bb234ecf4a77c128'
AND (
token = 'SC1sErid+Bee0+E8AJBDhxl5BAraIhmZvhJBcdByw4I='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)