UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'gjzuv5dPUdMPkbSA01TFxeZFHEfHrsCCYbRViy6/xKg='
WHERE
key_id = 'f9477373db4601b111a22293281c5bdf2ebe33f5a205401f4956b2d18a740dcc'
AND (
token = 'gjzuv5dPUdMPkbSA01TFxeZFHEfHrsCCYbRViy6/xKg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)