UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zQQRZI15vSMTFGyL6Zdv84ffg/p87NX9FU8bbsx3pQ8='
WHERE
key_id = '19017bae7754409a553bf8a71252c0cad334233a4c20d575fd3f68970373933f'
AND (
token = 'zQQRZI15vSMTFGyL6Zdv84ffg/p87NX9FU8bbsx3pQ8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)