UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'dSDKHEGKsqlrGEWa2fORs8HzSsIrdeYsJZSGuduWS2o='
WHERE
key_id = 'f07feba394c27b4467707d328eacb8e358b41e9b4922a3426742f880d05e3e27'
AND (
token = 'dSDKHEGKsqlrGEWa2fORs8HzSsIrdeYsJZSGuduWS2o='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)