UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8FijAwWiiqGTD1gneRk0MIcq9gWgOxzEBHVivxqqKmU='
WHERE
key_id = '27d60ead176fb3bbd6381f2a63bbbfac41d97945110a655ec895c1e68fe829b7'
AND (
token = '8FijAwWiiqGTD1gneRk0MIcq9gWgOxzEBHVivxqqKmU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)