UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'B475fGSI6rgwmOpSY8HL4dc43krLUu3ymRanmHEM2ts='
WHERE
key_id = '991403887455d4ec4c23398e4a72a2c8200ec05554f7889557537d32954133f2'
AND (
token = 'B475fGSI6rgwmOpSY8HL4dc43krLUu3ymRanmHEM2ts='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)