UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XqFy3onRLMK7i6kBbT+IsC7Ng2hKgvqvSdGeFCxMdig='
WHERE
key_id = '23d95afc8b8c8cd22515eba643d60e6b1838d7d16f821235bbfb36a99b0d1057'
AND (
token = 'XqFy3onRLMK7i6kBbT+IsC7Ng2hKgvqvSdGeFCxMdig='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)