UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'KYPnZd5D/+4eejfZehwZITxfBPhN2Z2cxuyxmGXWKsw='
WHERE
key_id = '02507b5441a5101359849ea7e5258fb1d0773123dbf3cade6a64e69db06906ee'
AND (
token = 'KYPnZd5D/+4eejfZehwZITxfBPhN2Z2cxuyxmGXWKsw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)