UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'N6s8wxrMhSXXXAqQu9eWZyWjsYFwaNI94mAoXsV/nYg='
WHERE
key_id = '93c81474ec07ebc29f248cdf01d7e7077b029adc1ec41c97e416de70b7de84ea'
AND (
token = 'N6s8wxrMhSXXXAqQu9eWZyWjsYFwaNI94mAoXsV/nYg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)