UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'GpqN8DrZojuKdaNKT7f2MS5ZqIzQuKderqEWCwMbG44='
WHERE
key_id = '46507bbd975f7cf9c49e31758a471126f45074bd12c5e4f9c595d436b05fae5b'
AND (
token = 'GpqN8DrZojuKdaNKT7f2MS5ZqIzQuKderqEWCwMbG44='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)