UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'f0t7Z+bY1Dw86KJIvFTFlKtM4Fo7WOZMkcfcOu4EF6c='
WHERE
key_id = '431597b7ed80e576cd9edbc01b084d4ce1cdfb2d07726c8204ffc99d0e8b2c6a'
AND (
token = 'f0t7Z+bY1Dw86KJIvFTFlKtM4Fo7WOZMkcfcOu4EF6c='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)