UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'U1hfPiXVW//k89jvpMW1Xt5SBV5jcDUhj9awf2pO5Zs='
WHERE
key_id = 'ef5a009b2083ec1e4c9832941badf5a67f934a9519c5fa6d662025795c9c3885'
AND (
token = 'U1hfPiXVW//k89jvpMW1Xt5SBV5jcDUhj9awf2pO5Zs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)