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