UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pGkHmoRBuRtw2mmHQpjOlMiagL0pTnamPuY9MxMFLuI='
WHERE
key_id = 'd1fedc961305a764cdf86b6a1ff2c6f3920d1e6872e1f86dd3d65991d0cfd535'
AND (
token = 'pGkHmoRBuRtw2mmHQpjOlMiagL0pTnamPuY9MxMFLuI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)