UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'KPS47X4iXsqrZeQ9Mw1Ift3WzPPdF3tWU4mPWcrSUJA='
WHERE
key_id = '76af34ab4b7f36f97f27064d617463d3cd749bd7ca22aa3327208ad0a54cc379'
AND (
token = 'KPS47X4iXsqrZeQ9Mw1Ift3WzPPdF3tWU4mPWcrSUJA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)