UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'TXUmbvohPu5hs9Mq1NtAu4yGQldI7dONfbjuJEEv1Yw='
WHERE
key_id = '4cb9c07d265383dbca56f9b9a032903cb7356b1cae8108f57852b89f6fe5498f'
AND (
token = 'TXUmbvohPu5hs9Mq1NtAu4yGQldI7dONfbjuJEEv1Yw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)